home *** CD-ROM | disk | FTP | other *** search
/ MacWorld 2003 May (DVD) / Macworld Resource DVD May 2003.toast / Data / Software / Bonus / Database / mysql-max-3.23.55.sit / mysql-max-3.23.55-apple-darwi.1 / mysql-test / r / func_if.result < prev    next >
Encoding:
Text File  |  2003-01-21  |  282 b   |  38 lines  |  [TEXT/ttxt]
  1. IF(0,"ERROR","this")    IF(1,"is","ERROR")    IF(NULL,"ERROR","a")    IF(1,2,3)|0    IF(1,2.0,3.0)+0
  2. this    is    a    2    2.0
  3. s
  4. a
  5. A
  6. a
  7. aa
  8. AA
  9. aaa
  10. BBB
  11. s
  12. a
  13. A
  14. a
  15. aa
  16. AA
  17. aaa
  18. BBB
  19. s
  20. A
  21. AA
  22. BBB
  23. a
  24. a
  25. aa
  26. aaa
  27. s
  28. A
  29. AA
  30. a
  31. a
  32. aa
  33. aaa
  34. sum(if(num is null,0.00,num))
  35. 144.54
  36. min(if(y -x > 5,y,NULL))    max(if(y - x > 5,y,NULL))
  37. 16    6
  38.